package com.originskyseed.platform.user.mapper;

import java.util.Date;
import java.util.List;
import java.util.Map;

import com.originskyseed.platform.user.model.PlayerRelateAnchorRecharge;
import org.apache.ibatis.annotations.Param;

/**
 * 玩家为主播累充信息表Mapper类（OSI_PLAYER_RELATE_ANCHOR_RECHARGE）
 * 
 * @author Tangwanghui
 */
public interface PlayerRelateAnchorRechargeMapper {

	/**
	 * 删除记录
	 * 
	 * @param id
	 * @return
	 * @throws Exception
	 */
	public int deleteByPrimaryKey(String id) throws Exception;

	/**
	 * 批量删除记录
	 * 
	 * @param ids
	 * @return
	 * @throws Exception
	 */
	public int deleteByPrimaryKeys(List<String> ids) throws Exception;

	/**
	 * 插入记录
	 * 
	 * @param record
	 * @return
	 * @throws Exception
	 */
	public int insert(PlayerRelateAnchorRecharge record) throws Exception;

	/**
	 * 插入记录（仅非空值字段）
	 * 
	 * @param record
	 * @return
	 * @throws Exception
	 */
	public int insertSelective(PlayerRelateAnchorRecharge record) throws Exception;

	/**
	 * 更新记录
	 * 
	 * @param record
	 * @return
	 * @throws Exception
	 */
	public int updateByPrimaryKey(PlayerRelateAnchorRecharge record) throws Exception;

	/**
	 * 更新记录（仅非空值字段）
	 * 
	 * @param record
	 * @return
	 * @throws Exception
	 */
	public int updateByPrimaryKeySelective(PlayerRelateAnchorRecharge record) throws Exception;

	/**
	 * 查询记录
	 * 
	 * @param id
	 * @return
	 * @throws Exception
	 */
	public PlayerRelateAnchorRecharge selectByPrimaryKey(String id) throws Exception;

	/**
	 * 查询记录,根据玩家id
	 *
	 * @param playerId
	 * @return
	 * @throws Exception
	 */
	public List<PlayerRelateAnchorRecharge> selectByPlayerId(@Param("playerId") String playerId) throws Exception;





	/**
	 * 批量更新
	 * @param playerIdList
	 * @param loginTime
	 * @param updateTime
	 * @return
	 * @throws Exception
	 */
	public int batchUpdateByPlayerId(@Param("list") List<String> playerIdList,@Param("loginTime") Date loginTime,@Param("updateTime")  Date updateTime) throws Exception;


	/**
	 * 查询记录,根据玩家id
	 *
	 * @param playerId
	 * @param anchorId
	 * @return
	 * @throws Exception
	 */
	public PlayerRelateAnchorRecharge selectByPlayerIdAndAnchorId(@Param("playerId")String playerId, @Param("anchorId") String anchorId) throws Exception;
	/**
	 * 查询列表
	 * 
	 * @param record
	 * @return
	 * @throws Exception
	 */
	public List<PlayerRelateAnchorRecharge> selectList(PlayerRelateAnchorRecharge record) throws Exception;

	/**
	 * 分页查询列表
	 * 
	 * @param params
	 * @return
	 * @throws Exception
	 */
	public List<PlayerRelateAnchorRecharge> selectListByPage(Map<String, Object> params) throws Exception;

}